[client]
default-character-set=utf8
socket={{ mysql_socket }}

[mysqld]
user = {{ mysql_user }} 
port = {{ mysql_port }}
basedir={{ basedir }}
datadir={{ datadir }}/data
socket={{mysql_socket}}
pid-file={{ datadir }}/data/mysqld.pid
default_authentication_plugin = mysql_native_password
init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
collation-server = utf8mb4_0900_ai_ci
skip-name-resolve
log-error={{ logdir }}/error.log
{% if mysql_db  == "master" %}
server-id = 1
{% else %}
server-id = 2
{% endif %}
log_bin=mysql-bin
lower_case_table_names = 1
log-bin-trust-function-creators = 1
default-time-zone = '+8:00'
interactive_timeout = 1800
wait_timeout = 1800
max_connections = 1000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
